package com.njym.java.security.admin.mapper;


import com.njym.java.security.admin.entity.PaymentRecord;
import com.njym.java.security.admin.entity.PaymentRecordVo;
import org.apache.ibatis.annotations.Param;
import tk.mybatis.mapper.common.Mapper;

import java.util.Date;
import java.util.List;

/**
 * 
 * 
 * @author zhy
 * @email ${email}
 * @date 2019-11-30 14:09:49
 */
public interface PaymentRecordMapper extends Mapper<PaymentRecord> {

	List<PaymentRecordVo> queryByEx(@Param("courseId") Integer courseId, @Param("timex") String timex);

	List<PaymentRecordVo> queryByQuater(@Param("courseId") Integer courseId);

	List<String> getSeasons();

	List<String> getSectionsByEx(@Param("timex") String timex);

	List<PaymentRecordVo> getTotals(@Param("startDate") Date startDate, @Param("endDate")  Date endDate, @Param("flag")  Integer flag);

	List<PaymentRecordVo> getTotalsByPerson(@Param("startDate") Date startDate, @Param("endDate")  Date endDate, @Param("flag")  Integer flag);
}
